UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '40CTYd4I1SEnhNr0USvnNtOX3TZ2y2IHxFfaffzjyo0='
WHERE
key_id = 'bd14021cf3d52284cd3651a8f6e90c3433c3a4c6a81912acd6ba65b622c6ff1b'
AND (
token = '40CTYd4I1SEnhNr0USvnNtOX3TZ2y2IHxFfaffzjyo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)