SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'df00dc725bb5a5dd1b3d2c4a978ed0bd8f056856ab029a7f8882c2e5b2df09af' 
  AND token = 'b5H0z7INgQy1Z6w0F9CbvcLwNbK6tkGF9uikZ/nyD3Y=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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