UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7f3PHRhTL8TQfCO0DpT8shEU0jmVUZZh7kp/gvxGSCY='
WHERE
key_id = 'ca0a7806e5533b25996915906607635852b98bc846ff20b19e9a6325624c9940'
AND (
token = '7f3PHRhTL8TQfCO0DpT8shEU0jmVUZZh7kp/gvxGSCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)