UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qn42IfPsJcncp+rYF0/0xYgeJdFi6FdJlekL3mP4Irs='
WHERE
key_id = '47dfdf9d528bf762de38d1baefcb2bf31c52f6ac147a79854cf76a62900be9f1'
AND (
token = 'Qn42IfPsJcncp+rYF0/0xYgeJdFi6FdJlekL3mP4Irs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)