UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X4E+iLNstwSat+KEkmR8bw6y/dqf6rNkAAfOYGQW/mI=' 
WHERE 
  key_id = '35da55efb66530bf4123b08911560f3a7c6e37d6927dbe40cc28280b48f2233e' 
  AND (
    token = 'X4E+iLNstwSat+KEkmR8bw6y/dqf6rNkAAfOYGQW/mI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041