UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HgxYt/vBjhQItXtlAk4lQlVtoSk3Jg08Zk/Eqv2bB9c=' 
WHERE 
  key_id = '550ea7cfe8551f41a27fcce9227135923251209948a6edeeae03a62aa9e4e191' 
  AND (
    token = 'HgxYt/vBjhQItXtlAk4lQlVtoSk3Jg08Zk/Eqv2bB9c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034