UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9BrMfvW1BW+Ui5tfclVIXaGvbnLfr1kUaa2Wi2NQLzs='
WHERE
key_id = '78d36329ae12af0b1c3028eb76ab2ead75e1ae331a8523b492f479730904ec5e'
AND (
token = '9BrMfvW1BW+Ui5tfclVIXaGvbnLfr1kUaa2Wi2NQLzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)