UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xL/5cSnZenm5v9XIvwZL4o0gIaASWSCSM109ifkrvs='
WHERE
key_id = 'f7be5edf8aeff80507ad04347a8b2e6e80a79d81455ff11cad9ab0c0bb70c0bc'
AND (
token = '7xL/5cSnZenm5v9XIvwZL4o0gIaASWSCSM109ifkrvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)