UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yfxSCNsQLAehB2ax+g8JSeKmccSFN9yKcw3kG7Hn/8c='
WHERE
key_id = '536c6e93ce021bcc172c86d14f449cf639eaedc8efb2945b94cbae3b0294ee41'
AND (
token = 'yfxSCNsQLAehB2ax+g8JSeKmccSFN9yKcw3kG7Hn/8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)