UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QZiTbjnr+2UXbttRe1LhX5uG0tm5K7LEgrdW0YX9zSg='
WHERE
key_id = 'f979996952ab0412c83075bbe3fa31164d25efb360ea4437f962fed5117e5656'
AND (
token = 'QZiTbjnr+2UXbttRe1LhX5uG0tm5K7LEgrdW0YX9zSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)