UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nw0mA5uZOegsHRe9icN3g3QTXcdl2RmG8MRdn1/x7L8='
WHERE
key_id = 'afad4f7ca4678c89ed0cc44f346f9779b788534abb8eeb7887ae120d3b88924e'
AND (
token = 'nw0mA5uZOegsHRe9icN3g3QTXcdl2RmG8MRdn1/x7L8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)