UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FCyALg3QKluoGd3W89V1A8OG2i10w4DUj3wUvrCKjkw='
WHERE
key_id = '31d1fd408d217c08f2bbe339a9cd6f18447cbac4369e59ac627f7e98252be507'
AND (
token = 'FCyALg3QKluoGd3W89V1A8OG2i10w4DUj3wUvrCKjkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)