UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CYyUDOm4uVlIW79UORnCqmmnVGp1kONNYiWGFW7ILEY='
WHERE
key_id = 'b13317c29a69fd4a6b355534e1802b6ea603e4a748fe31a65b76007668689ccd'
AND (
token = 'CYyUDOm4uVlIW79UORnCqmmnVGp1kONNYiWGFW7ILEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)