UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihMWvH4IM3YKNhg6b4J1JrNQ6+85mPHvhMPOFL9F8HM='
WHERE
key_id = '01cd8c75e1ae53f80131f9cfb3791e2cbdb74444c51c411d85e8b21c455d57f0'
AND (
token = 'ihMWvH4IM3YKNhg6b4J1JrNQ6+85mPHvhMPOFL9F8HM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)