SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '516d1fc39eb9a488fadead4b18da6675b1d5079dd2bcff79d25ec578df3b4878' 
  AND token = 'qmb+Td4boFgFLandgSSHxkv31I709U/2v5p9iySntFQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00055

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}