UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XVn2uPxsVss75gGHCfcomJkkhYTTXNQ49ADXJX9CuVs='
WHERE
key_id = '0b778b33190f7286ac9251d82128227ed9d28a0db22df36b287bf2708f2824bf'
AND (
token = 'XVn2uPxsVss75gGHCfcomJkkhYTTXNQ49ADXJX9CuVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)