UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g9rgbeVNcqNQlUBm/YP3gW4NG8xhr0MNLPp13zUP0tE='
WHERE
key_id = 'a6a268f8abeeda6095e4b93b4ed142b14e55a9dbe3e4c96628dddd1e47e157eb'
AND (
token = 'g9rgbeVNcqNQlUBm/YP3gW4NG8xhr0MNLPp13zUP0tE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)