UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8DLTWq02U3v+crvc+bI0x3EJ/MBciWRFAj1noY67WsM='
WHERE
key_id = '0fed0964907712283863af23a9324f208a87ccfa676c63d0b3f148bcb5ddcb59'
AND (
token = '8DLTWq02U3v+crvc+bI0x3EJ/MBciWRFAj1noY67WsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)