SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '38d849b94dff75de6e74cc21dc32d93da3452179a443b40702be0ea9b14ff020' 
  AND token = 'qzTx30JOE/byZWeK4zWC1P3WAXPQss2vfS5ISN16tTE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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