UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XfqIeA0D+8rTrwD9SxirBgeKU4K/9SE3CgkU4pTE1o='
WHERE
key_id = '8cf9733824fff06d35b6e8be4511c1c2bbfe4d4f72f1dc8b8e598807b0bb261a'
AND (
token = '5XfqIeA0D+8rTrwD9SxirBgeKU4K/9SE3CgkU4pTE1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)