UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEWLUUX+MLgq4dgwk/HYrMDMIYMQn9skYY8+1W/SKXE='
WHERE
key_id = '10bd249f131e41a46a87848a9f903f2ce50ac0df8e5b57d72473a53d02ce27c7'
AND (
token = 'zEWLUUX+MLgq4dgwk/HYrMDMIYMQn9skYY8+1W/SKXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)