UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C0afob94ytI3igq2URCWmuGkunWSrEDBXXPt4TWq3Yk='
WHERE
key_id = '7842ce183eda3d9155333fc36c389158015bc6cb2519477683e9ecae462091fe'
AND (
token = 'C0afob94ytI3igq2URCWmuGkunWSrEDBXXPt4TWq3Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)