UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LBBsl4vhvDNhw2vONlJ7E2hEd/ojFMUUTz8HPN8yeVM=' 
WHERE 
  key_id = '6934ee34297226f2f2dde1bc231c52548c8180764350015d2732b546ebf19bae' 
  AND (
    token = 'LBBsl4vhvDNhw2vONlJ7E2hEd/ojFMUUTz8HPN8yeVM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030