UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aLlXqKBhc5u0yYl7Z4BIJIpxeiyCRSuceAPf4pM9Ogc='
WHERE
key_id = '554d0f962bba9e0a01f0ebec317e7c79644b11d1279a84b5f804936982a4f2dd'
AND (
token = 'aLlXqKBhc5u0yYl7Z4BIJIpxeiyCRSuceAPf4pM9Ogc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)