UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dl8kVzjerlTq1u/bckqGOmECgxXEm9rQRG6vNmDy7pc='
WHERE
key_id = 'faaf6794db6d251beda03399e4e5aab30cf4dc30e480490109f23e56930fd49e'
AND (
token = 'dl8kVzjerlTq1u/bckqGOmECgxXEm9rQRG6vNmDy7pc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)