SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8488dd0a8ad1579f73880ebe71c035ba3a311384525e962c9f033d0aa4e2ceb9' 
  AND token = 'Q1li8i7V2SVaUg5KiuOuwZHVwtnhEcXVGifsvW2p6xQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}