UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u9J4EjNllmNQRdIse/l4urYl/Cvsy4jKAqKnKaL7tSs='
WHERE
key_id = '7e9b1d71cf5d59d134be9f8051942ae47339490bbda201d9872b3cf2075f3c4b'
AND (
token = 'u9J4EjNllmNQRdIse/l4urYl/Cvsy4jKAqKnKaL7tSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)