UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9kJorluEsit6D1BHGecLuieRCgd9oqF3N7eIek3SBD8='
WHERE
key_id = 'ef20370d05f579512fe2b618f1bb3cf311e4dac668d83a1fd3e1e6e8caee9060'
AND (
token = '9kJorluEsit6D1BHGecLuieRCgd9oqF3N7eIek3SBD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)