UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oNwUNH2v4fGbnW5SRjv5NM0LOefxKSowpFDbvbEveY='
WHERE
key_id = 'ee10437bef950d5796f894af97837c67f2323c13d23192d32d7b0860a2ec788c'
AND (
token = '8oNwUNH2v4fGbnW5SRjv5NM0LOefxKSowpFDbvbEveY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)