UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'khc26DIaUs0xv8a+ZC6+2wirgh2Y2+Wg4qbNhxZ2iDg='
WHERE
key_id = 'cd7fd9a182b82f021be22dbca89300547c1c22a2489850ac9e3783a8328c36bb'
AND (
token = 'khc26DIaUs0xv8a+ZC6+2wirgh2Y2+Wg4qbNhxZ2iDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)