UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7q0imAGxXBTiShFiyuDr3vvGDDH/dEABy81ggV+Br2c=' 
WHERE 
  key_id = 'e3d4eb7acb8790dcb8c78f965ec230eaa29e85b7fd88c86245c26cefed0b2778' 
  AND (
    token = '7q0imAGxXBTiShFiyuDr3vvGDDH/dEABy81ggV+Br2c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027